excel数据透视表_Excel数据透视表排序问题

excel数据透视表

Usually, it's easy to sort an Excel pivot table – just click the drop down arrow in a pivot table heading, and select one of the sort options. Occasionally though, you might run into pivot table sorting problems, where some items aren't in A-Z order.

通常，对Excel数据透视表进行排序很容易–只需单击数据透视表标题中的下拉箭头，然后选择一种排序选项即可。 但是，有时您可能会遇到数据透视表排序问题，其中某些项目不是按AZ顺序排列的。

数据透视表排序问题 (Pivot Table Sorting Problems)

In some cases, the pivot table items might not sort the way that you'd expect. In this example, there are sales representative names in column A, and they have been sorted alphabetically, A-Z.

在某些情况下，数据透视表项可能无法按照您期望的方式排序。 在此示例中，列A中有销